﻿using System.Collections.Generic;

namespace Citi.FinancePlanningAnalysis.Domain
{
    public partial class GlAccount
    {
        #region Mappings

        public static readonly Dictionary<string, string> ExcelColumnMappings = new Dictionary<string, string> { 
                {"[GL_ACCT_ID]", "[Code]"},
                {"[EFF_STATUS]", "[Status]"},
                {"[GL_ACCT_SHRT_NM]", "[ShortDescription]"},
                {"[GL_ACCT_NM]", "[LongDescription]"},
                {"[EFFDT]", "[EffectiveDate]"}
            };
        					
        #endregion

        public const string QueryMergeDate = "EXEC sp_MergeGlAccount";
        public const string QueryDeletePrevious = "DELETE FROM GlAccountTemp";

        public const string QueryExcel = @"SELECT 
                [GL_ACCT_ID],
                [EFF_STATUS],
                [GL_ACCT_SHRT_NM],
                [GL_ACCT_NM],
                [EFFDT]
                FROM [{0}$] WHERE GL_ACCT_ID <> 'NA'";
    }
}
